package jdbc;

import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 数据库工具类,用此类管理数据库的连接
 * */
public class DBUtil {
    private static DruidDataSource dataSource = new DruidDataSource();
    static {
        dataSource.setUrl("jdbc:mysql://localhost:3306/tedu?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true");
        dataSource.setUsername("root");
        dataSource.setPassword("root");
        dataSource.setMaxActive(10);//设置最大连接量
        dataSource.setInitialSize(5);//设置初始化连接值
           }
    public static Connection getConnection() throws SQLException {
        return dataSource.getConnection();//直接用dataSource建立连接返回
    }
}
